{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='DS')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['长安标致雪铁龙>>', '进口DS>>'], dtype=object)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = LSG_price[LSG_price['factory']!='进口DS>>']\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "\n",
    "LSG = all1[(all1['3']=='LPA')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CAP7160HAE3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1586</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA3CHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CAP7160JAE3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1598</td>\n",
       "      <td>130</td>\n",
       "      <td>LPAA3CHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CAP7181FAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CAP7181FAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CAP7181FAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CAP7181FAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CAP7181FAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1600</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1600</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CAP7161HAE2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1530</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA2FHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CAP7161JAE2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1515</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>130</td>\n",
       "      <td>LPAA2FHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CAP7180FAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1520</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA2FFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CAP7161EAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA2FDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CAP7180FAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1520</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA2FFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CAP7161EAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA2FDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CAP7161EAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA2FDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CAP7180FAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1520</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA2FFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CAP7161EAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA2FDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CAP7120GAC21</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1420</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LPAA2FGC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CAP7120GAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1420</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LPAA2FGC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CAP7180CAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1455</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LPAA2FCC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CAP7180CMC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1420</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LPAA2FCA×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CAP7161BAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1520</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA2FBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CAP7161AAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CAP7180CAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1455</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LPAA2FCC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CAP7180CMC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1420</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LPAA2FCA×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CAP7161DAC2</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1475</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702</td>\n",
       "      <td>1840</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4702x1840x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>CAP7160EAD4</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1472</td>\n",
       "      <td>2715</td>\n",
       "      <td>4435</td>\n",
       "      <td>1843</td>\n",
       "      <td>1510</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA4CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4435x1843x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>CAP7121GAD4</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1421</td>\n",
       "      <td>2715</td>\n",
       "      <td>4435</td>\n",
       "      <td>1843</td>\n",
       "      <td>1510</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LPAA4CGC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2715</td>\n",
       "      <td>4435x1843x1510</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>CAP7160DAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>CAP7181FAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1620</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>CAP7160DAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>CAP7181FAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1620</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>CAP7160EAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1600</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA1CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>CAP7181FAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1620</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>CAP7181FAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1620</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>CAP7160A2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>CAP7160A2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>CAP7160DAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>CAP7160B2A1C</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>CAP7160B2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>CAP7160B2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>CAP7181FAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1620</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1751</td>\n",
       "      <td>150</td>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>CAP7160EAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1600</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA1CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>CAP7160DAC1</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>CAP7160B2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>CAP7160A2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>CAP7160A2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>CAP7160B2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>CAP7160B2A1C</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>CAP7160A2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>CAP7160A2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>120</td>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>CAP7160B2A1A</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>CAP7160B2A1B</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>CAP7160B2A1C</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1598</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530</td>\n",
       "      <td>1871</td>\n",
       "      <td>1520</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2727</td>\n",
       "      <td>4530x1871x1520</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>CAP7160EAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1525</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1588</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LPAA3CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1588</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>CAP7160BAC3</td>\n",
       "      <td>谛艾仕</td>\n",
       "      <td>1540</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553</td>\n",
       "      <td>1858</td>\n",
       "      <td>1588</td>\n",
       "      <td>1598</td>\n",
       "      <td>147</td>\n",
       "      <td>LPAA3CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>LPA</td>\n",
       "      <td>2732</td>\n",
       "      <td>4553x1858x1588</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0    CAP7160HAE3     谛艾仕        1586      2732       4553      1858   \n",
       "1    CAP7160JAE3     谛艾仕        1540      2732       4553      1858   \n",
       "2    CAP7181FAC3     谛艾仕        1540      2732       4553      1858   \n",
       "3    CAP7181FAC3     谛艾仕        1540      2732       4553      1858   \n",
       "4    CAP7181FAC3     谛艾仕        1540      2732       4553      1858   \n",
       "5    CAP7181FAC3     谛艾仕        1540      2732       4553      1858   \n",
       "6    CAP7181FAC3     谛艾仕        1540      2732       4553      1858   \n",
       "7    CAP7161HAE2     谛艾仕        1530      2715       4702      1840   \n",
       "8    CAP7161JAE2     谛艾仕        1515      2715       4702      1840   \n",
       "9    CAP7180FAC2     谛艾仕        1520      2715       4702      1840   \n",
       "10   CAP7161EAC2     谛艾仕        1475      2715       4702      1840   \n",
       "11   CAP7180FAC2     谛艾仕        1520      2715       4702      1840   \n",
       "12   CAP7161EAC2     谛艾仕        1475      2715       4702      1840   \n",
       "13   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "14   CAP7161EAC2     谛艾仕        1475      2715       4702      1840   \n",
       "15   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "16   CAP7180FAC2     谛艾仕        1520      2715       4702      1840   \n",
       "17   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "18   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "19   CAP7161EAC2     谛艾仕        1475      2715       4702      1840   \n",
       "20  CAP7120GAC21     谛艾仕        1420      2715       4702      1840   \n",
       "21   CAP7120GAC2     谛艾仕        1420      2715       4702      1840   \n",
       "22   CAP7180CAC2     谛艾仕        1455      2715       4702      1840   \n",
       "23   CAP7180CMC2     谛艾仕        1420      2715       4702      1840   \n",
       "24   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "25   CAP7161BAC2     谛艾仕        1520      2715       4702      1840   \n",
       "26   CAP7161AAC2     谛艾仕        1475      2715       4702      1840   \n",
       "27   CAP7180CAC2     谛艾仕        1455      2715       4702      1840   \n",
       "28   CAP7180CMC2     谛艾仕        1420      2715       4702      1840   \n",
       "29   CAP7161DAC2     谛艾仕        1475      2715       4702      1840   \n",
       "..           ...     ...         ...       ...        ...       ...   \n",
       "36   CAP7160EAD4     谛艾仕        1472      2715       4435      1843   \n",
       "37   CAP7121GAD4     谛艾仕        1421      2715       4435      1843   \n",
       "38   CAP7160DAC1     谛艾仕        1540      2727       4530      1871   \n",
       "39   CAP7181FAC1     谛艾仕        1620      2727       4530      1871   \n",
       "40   CAP7160DAC1     谛艾仕        1540      2727       4530      1871   \n",
       "41   CAP7181FAC1     谛艾仕        1620      2727       4530      1871   \n",
       "42   CAP7160EAC1     谛艾仕        1600      2727       4530      1871   \n",
       "43   CAP7181FAC1     谛艾仕        1620      2727       4530      1871   \n",
       "44   CAP7181FAC1     谛艾仕        1620      2727       4530      1871   \n",
       "45  CAP7160A2A1B     谛艾仕        1540      2727       4530      1871   \n",
       "46  CAP7160A2A1A     谛艾仕        1540      2727       4530      1871   \n",
       "47   CAP7160DAC1     谛艾仕        1540      2727       4530      1871   \n",
       "48  CAP7160B2A1C     谛艾仕        1598      2727       4530      1871   \n",
       "49  CAP7160B2A1A     谛艾仕        1598      2727       4530      1871   \n",
       "50  CAP7160B2A1B     谛艾仕        1598      2727       4530      1871   \n",
       "51   CAP7181FAC1     谛艾仕        1620      2727       4530      1871   \n",
       "52   CAP7160EAC1     谛艾仕        1600      2727       4530      1871   \n",
       "53   CAP7160DAC1     谛艾仕        1540      2727       4530      1871   \n",
       "54  CAP7160B2A1A     谛艾仕        1598      2727       4530      1871   \n",
       "55  CAP7160A2A1B     谛艾仕        1540      2727       4530      1871   \n",
       "56  CAP7160A2A1A     谛艾仕        1540      2727       4530      1871   \n",
       "57  CAP7160B2A1B     谛艾仕        1598      2727       4530      1871   \n",
       "58  CAP7160B2A1C     谛艾仕        1598      2727       4530      1871   \n",
       "59  CAP7160A2A1B     谛艾仕        1540      2727       4530      1871   \n",
       "60  CAP7160A2A1A     谛艾仕        1540      2727       4530      1871   \n",
       "61  CAP7160B2A1A     谛艾仕        1598      2727       4530      1871   \n",
       "62  CAP7160B2A1B     谛艾仕        1598      2727       4530      1871   \n",
       "63  CAP7160B2A1C     谛艾仕        1598      2727       4530      1871   \n",
       "64   CAP7160EAC3     谛艾仕        1525      2732       4553      1858   \n",
       "65   CAP7160BAC3     谛艾仕        1540      2732       4553      1858   \n",
       "\n",
       "   car_height Displacement power                vin    car_factory    3  \\\n",
       "0        1600         1598   147  LPAA3CHC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "1        1600         1598   130  LPAA3CHC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "2        1600         1751   150  LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "3        1600         1751   150  LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "4        1600         1751   150  LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "5        1600         1751   150  LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "6        1600         1751   150  LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "7        1510         1598   147  LPAA2FHC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "8        1510         1598   130  LPAA2FHC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "9        1510         1751   150  LPAA2FFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "10       1510         1598   123  LPAA2FDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "11       1510         1751   150  LPAA2FFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "12       1510         1598   123  LPAA2FDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "13       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "14       1510         1598   123  LPAA2FDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "15       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "16       1510         1751   150  LPAA2FFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "17       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "18       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "19       1510         1598   123  LPAA2FDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "20       1510         1199   100  LPAA2FGC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "21       1510         1199   100  LPAA2FGC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "22       1510         1813   102  LPAA2FCC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "23       1510         1813   102  LPAA2FCA×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "24       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "25       1510         1598   147  LPAA2FBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "26       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "27       1510         1813   102  LPAA2FCC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "28       1510         1813   102  LPAA2FCA×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "29       1510         1598   120  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "..        ...          ...   ...                ...            ...  ...   \n",
       "36       1510         1598   123  LPAA4CDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "37       1510         1199   100  LPAA4CGC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "38       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "39       1520         1751   150  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "40       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "41       1520         1751   150  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "42       1520         1598   123  LPAA1CDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "43       1520         1751   150  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "44       1520         1751   150  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "45       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "46       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "47       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "48       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "49       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "50       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "51       1520         1751   150  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "52       1520         1598   123  LPAA1CDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "53       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "54       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "55       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "56       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "57       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "58       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "59       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "60       1520         1598   120  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "61       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "62       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "63       1520         1598   147  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "64       1588         1598   123  LPAA3CDC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "65       1588         1598   147  LPAA3CBC×××××××××  长安标致雪铁龙汽车有限公司  LPA   \n",
       "\n",
       "   轴距[mm]       长×宽×高[mm] brand_y   style  factory  \n",
       "0    2732  4553x1858x1600      DS    DS 6        4  \n",
       "1    2732  4553x1858x1600      DS    DS 6        4  \n",
       "2    2732  4553x1858x1600      DS    DS 6        4  \n",
       "3    2732  4553x1858x1600      DS    DS 6        4  \n",
       "4    2732  4553x1858x1600      DS    DS 6        4  \n",
       "5    2732  4553x1858x1600      DS    DS 6        4  \n",
       "6    2732  4553x1858x1600      DS    DS 6        4  \n",
       "7    2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "8    2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "9    2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "10   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "11   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "12   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "13   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "14   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "15   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "16   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "17   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "18   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "19   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "20   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "21   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "22   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "23   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "24   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "25   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "26   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "27   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "28   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "29   2715  4702x1840x1510      DS  DS 5LS       13  \n",
       "..    ...             ...     ...     ...      ...  \n",
       "36   2715  4435x1843x1510      DS   DS 4S        5  \n",
       "37   2715  4435x1843x1510      DS   DS 4S        5  \n",
       "38   2727  4530x1871x1520      DS    DS 5       14  \n",
       "39   2727  4530x1871x1520      DS    DS 5       14  \n",
       "40   2727  4530x1871x1520      DS    DS 5       14  \n",
       "41   2727  4530x1871x1520      DS    DS 5       14  \n",
       "42   2727  4530x1871x1520      DS    DS 5       14  \n",
       "43   2727  4530x1871x1520      DS    DS 5       14  \n",
       "44   2727  4530x1871x1520      DS    DS 5       14  \n",
       "45   2727  4530x1871x1520      DS    DS 5       14  \n",
       "46   2727  4530x1871x1520      DS    DS 5       14  \n",
       "47   2727  4530x1871x1520      DS    DS 5       14  \n",
       "48   2727  4530x1871x1520      DS    DS 5       14  \n",
       "49   2727  4530x1871x1520      DS    DS 5       14  \n",
       "50   2727  4530x1871x1520      DS    DS 5       14  \n",
       "51   2727  4530x1871x1520      DS    DS 5       14  \n",
       "52   2727  4530x1871x1520      DS    DS 5       14  \n",
       "53   2727  4530x1871x1520      DS    DS 5       14  \n",
       "54   2727  4530x1871x1520      DS    DS 5       14  \n",
       "55   2727  4530x1871x1520      DS    DS 5       14  \n",
       "56   2727  4530x1871x1520      DS    DS 5       14  \n",
       "57   2727  4530x1871x1520      DS    DS 5       14  \n",
       "58   2727  4530x1871x1520      DS    DS 5       14  \n",
       "59   2727  4530x1871x1520      DS    DS 5       14  \n",
       "60   2727  4530x1871x1520      DS    DS 5       14  \n",
       "61   2727  4530x1871x1520      DS    DS 5       14  \n",
       "62   2727  4530x1871x1520      DS    DS 5       14  \n",
       "63   2727  4530x1871x1520      DS    DS 5       14  \n",
       "64   2732  4553x1858x1588      DS    DS 6        7  \n",
       "65   2732  4553x1858x1588      DS    DS 6        7  \n",
       "\n",
       "[66 rows x 17 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "轴距[mm]  长×宽×高[mm]       style \n",
       "2715    4435x1843x1510  DS 4S      5\n",
       "        4702x1840x1510  DS 5LS    13\n",
       "2727    4530x1871x1520  DS 5      14\n",
       "2732    4553x1858x1588  DS 6       7\n",
       "        4553x1858x1600  DS 6       4\n",
       "        4553x1858x1610  DS 6       4\n",
       "Name: factory, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','style'])['factory'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LPAA3CHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LPAA3CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPAA2FHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>LPAA2FFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>LPAA2FDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LPAA2FAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>LPAA2FGC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>LPAA2FCC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>LPAA2FCA×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>LPAA2FBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5LS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>LPAA4CHC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>LPAA4CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>LPAA4CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>LPAA4CGC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 4S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>LPAA1CAC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>LPAA1CFC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>LPAA1CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>LPAA1CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>LPAA3CDC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>LPAA3CBC×××××××××</td>\n",
       "      <td>长安标致雪铁龙汽车有限公司</td>\n",
       "      <td>DS</td>\n",
       "      <td>DS 6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  vin    car_factory brand   style\n",
       "0   LPAA3CHC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 6\n",
       "2   LPAA3CFC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 6\n",
       "7   LPAA2FHC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "9   LPAA2FFC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "10  LPAA2FDC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "13  LPAA2FAC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "20  LPAA2FGC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "22  LPAA2FCC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "23  LPAA2FCA×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "25  LPAA2FBC×××××××××  长安标致雪铁龙汽车有限公司    DS  DS 5LS\n",
       "31  LPAA4CHC×××××××××  长安标致雪铁龙汽车有限公司    DS   DS 4S\n",
       "33  LPAA4CDC×××××××××  长安标致雪铁龙汽车有限公司    DS   DS 4S\n",
       "34  LPAA4CFC×××××××××  长安标致雪铁龙汽车有限公司    DS   DS 4S\n",
       "37  LPAA4CGC×××××××××  长安标致雪铁龙汽车有限公司    DS   DS 4S\n",
       "38  LPAA1CAC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 5\n",
       "39  LPAA1CFC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 5\n",
       "42  LPAA1CDC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 5\n",
       "48  LPAA1CBC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 5\n",
       "64  LPAA3CDC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 6\n",
       "65  LPAA3CBC×××××××××  长安标致雪铁龙汽车有限公司    DS    DS 6"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('DS_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
